<?php

require_once( '../system/smarty.inc' );

require_once( '../system/mdao/Class_D_DNP_AREA.php' );
require_once( '../system/mdao/Class_M_OTHER.php' );

require_once( '../system/Class_ERROR.php' );
require_once( '../system/login.inc.php' );
require_once( '../system/aoki_m.php' );
require_once( '../system/Class_PWD.php' );

Class_PWD::valid_auth(AOKI_AUTH_DNP_AREA, $login['staff_auth']);
$isG5  = FALSE;
if   ($login['staff_auth'] == 'G-5') {
	$isG5 = TRUE;
}

$dosearch = FALSE ;
$dao = new Class_D_DNP_AREA;

$pattern = Class_M_OTHER::get_pattern_array(PLEASE_SELECT_ARR, 3);
$dists   = Class_M_OTHER::get_dist_array( );
//$hands   = Class_M_OTHER::get_hand_array( );

if ( isset( $_GET['csv'] ) &&  (  $_GET['csv'] == "download" ) ||
	 isset( $_GET['hist'] ) &&  (  $_GET['hist'] == "2" ) ) {
	 $forms =  $_SESSION['MSEARCH']['AREA_AD'];
}else {
	$forms = $_GET;
	$_SESSION['MSEARCH']['AREA_AD'] = $forms;
}

$wherearr =  array();

/*
if ( isset( $forms['media_name'] ) &&  ( !empty( $forms['media_name'] ) ) ){
	$wherearr[] = sprintf(" media_name =  '%s' ", $forms['media_name'] );
}
*/
	if ( isset( $forms['hand_name'] ) &&  ( !empty( $forms['hand_name'] ) ) ){
		$wherearr[] = sprintf(" h.hand_name like  '%s' ",  "%".$forms['hand_name']."%" );
	}
	$centernums = array();
	if ( isset( $forms['pattern_cd'] ) &&  ( !empty( $forms['pattern_cd'] ) ) ){
		$wherearr[] = sprintf(" a.pattern_cd =  '%s' ",$forms['pattern_cd'] );
		
		$centernums =  $dao->getcentercount( $forms["pattern_cd"] );
	}
	
	if ( isset( $forms['upd_f'] ) &&  ( !empty( $forms['upd_f'] ) ) ){
		$wherearr[] = Class_PWD::get_u_time_where_sql($forms['upd_f'], 1 );
	}
	
	if ( isset( $forms['upd_t'] ) &&  ( !empty( $forms['upd_t'] ) ) ){
		$wherearr[] = Class_PWD::get_u_time_where_sql($forms['upd_t'],2 );
	}
	
	
/*
	$centernums["c_area_nums"] = empty($centernums["c_area_nums"]) ? 0 : $centernums["c_area_nums"] ;
	$centernums["c_shop_per"]  = empty($centernums["c_shop_per"] ) ? 0 : $centernums["c_shop_per"] ;
	$centernums["c_shop_nums"] = empty($centernums["c_shop_nums"]) ? 0 : $centernums["c_shop_nums"] ;
*/
	
//---CSVダウンロード　処理開始

if ( isset( $_GET['csv'] ) &&  (  $_GET['csv'] == "download" ) ){
	/*
	$_GET["csv"] = "";
	$tmpfilename = "areaad".date("Ymd_His");
	header("Content-Type: application/octet-stream"); 
	header("Content-Disposition: attachment; filename=$tmpfilename.csv");
	$data = $dao->searchcsv( $wherearr, $shop_name );
	$colums = array();
	$col_heads = array(
		'matrix_cd'        => array( 'マトリックスID',  1),
		'year4'            => array( '年度',            1),
		'week_cd'          => array( '週',              1),
		'flier_date'       => array( '折込日',          1),
		'area_cd'          => array( 'エリアコード',    1),
		'area_name'        => array( 'エリア名',        1),
		'publish_area_name'=> array( '配布エリア名',    1),
		'area_nums'        => array( 'エリア部数',      1),
		'hand_name'        => array( '取扱業者',        1),
		'media_name'       => array( '媒体名',          1),
		'memo'             => array( '備考',            1),
		'shop_cd'          => array( '店舗コード',      1),
		'shop_name'        => array( '店舗名',          1),
		'shop_per'         => array( '店舗部数%',       1),
		'shop_nums'        => array( '計算部数',        1),
		'u_time'           => array( '更新日時',        3),
		'c_time'           => array( '登録日時',        3),
		'm_user_name'      => array( '更新者',          1)
	);

	//列名
	foreach ($col_heads as $k=>$v) {
		$colums["name"][]   = $k;
		$colums["head"][]   = $v[0];
		$colums["type"][$k] = $v[1];
	}
	//データ整形開始
	foreach ($data as $k => $v) {
		$data[$k]["flier_date"]  =  Class_PWD::int8_to_date($v["flier_date"]);
		$data[$k]["c_time"]      =  Class_PWD::dateTime_to_YmdHi($v["c_time"]);
		$data[$k]["u_time"]      =  Class_PWD::dateTime_to_YmdHi($v["u_time"]);
	}
	//データ整形完了
	$dao->output_csv($data, $colums);
	*/
	exit;
}


//---CSVダウンロード　処理完了

if ( isset( $forms['search'] ) && (  !empty( $forms['search'] ) ) ){
	$dosearch = TRUE;
}

if( isset( $forms['page'] ) && is_numeric( $forms['page'] ) ){
	$dosearch = TRUE;
	$page['current'] = $forms['page'];
}else{
	$page['current'] = 1;
}

$page['item'] = PAGE_MAX;

if ($dosearch) {
	//$page内容は関数内部更新されます。
	$data = $dao->search( $wherearr, $page );
	$page["cnt"]= count($data);
	//表示ために整形開始
	foreach ($data as $k => $v ) {
		$data[$k]["pattern_name"] =$pattern[ $v["pattern_cd"] ] ;
		$data[$k]["dist_name"] =$dists[ $v["dist_id"] ] ;
		//$data[$k]["hand_name"] =$hands[ $v["hand_cd"] ] ;
	}
}
//表示ために整形完了
/*
if (empty($forms["year4"])) {
	$forms["year4"] = date('Y');
}
$smarty->assign('year4',  Class_PWD::get_years());

$week= Class_M_OTHER::get_week_array( $forms["year4"], PLEASE_SELECT_ARR, TRUE );

$smarty->assign('week', $week );
*/
if( isset($forms) ) $smarty->assign('forms', $forms);
if( isset($data) )  $smarty->assign('data', $data);

if( isset($centernums) )  $smarty->assign('center', $centernums);
if( isset($page) )  $smarty->assign('page', $page);
$smarty->assign('pattern', $pattern );

$smarty->assign('isG5', $isG5 );
/*
$block = Class_M_OTHER::get_block_array( PLEASE_SELECT_ARR );
$smarty->assign('block', $block );

$local= Class_M_OTHER::get_local_array( PLEASE_SELECT_ARR );
$smarty->assign('local', $local );


$flags[""] = "すべて";
foreach ($aoki_disp_flags as $k => $v) {
	$flags[$k] = $v;
}
$smarty->assign('flags', $flags );

//get_pattern_array($please_select = NULL, $sort = 0)


$notisg5 = TRUE ;
if   ($login['staff_auth'] == 'G-5') {
	$notisg5 = FALSE ;
}
$smarty->assign('notisg5', $notisg5 );
*/
$smarty->assign('menu', $smarty->fetch('menu.html') );
$smarty->assign('logout', $smarty->fetch('logout.html') );
$smarty->assign('footer', $smarty->fetch('footer.html') );
$smarty->assign('pageing', $smarty->fetch('page.html') );
$smarty->display('ddnparea_index.html');
?>